<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/md5.asp"-->
<!--#include file="../common/admin.asp"-->
<%
orderid=request.QueryString("id")
set rs=server.CreateObject("adodb.recordset")
sql="select * from PackageOrder where [order]='"&orderid&"'"
rs.open sql,conn,1,3
if not rs.eof then	
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>add</title>
<link href="../css/style.css" rel="stylesheet" type="text/css"/>
<style>body {background-color: #eaece1;}</style>
</head>

<body>
<div class="main">
  <div class="main-title">操作</div>
  <div class="main-content">
  <table width="100%" border="0" cellspacing="1" cellpadding="3" class="tab">
  <tr>
    <td colspan="2" bgcolor="#FFFFFF">
    
    <table width="100%" border="0" cellspacing="0" cellpadding="0" class="table_style">
        	  <tr>
        	    <th width="45%">产品</th>
        	    <th width="18%" align="center">重量</th>
        	    <th width="13%" align="center"> 数量 </th>
        	    <th width="18%" align="center">入库时间</th>
       	      </tr>
              <%
		set rslist=server.CreateObject("adodb.recordset")
		sql="select * from PackageOrderDetail where [order]="&rs("order")&""
		rslist.open sql,conn,1,3
		if not rslist.eof then
		do while not rslist.eof
		
		
		             if rslist("typeid")="1" then
					     set rsproduct=conn.execute("select * from AuctionsOrder where id="&rslist("oid")&"") '产品
						 sqlField="WarehouseTime"
					  else
					     set rsproduct=conn.execute("select * from OrderDetail where id="&rslist("oid")&"") '产品
						 sqlField="StoragedTime"
					  end if
		%>
        	  <tr>
        	    <td align="center">
                
                <%=rsproduct("title")%>
          
                
                </td>
        	    <td align="center"> <%=rsproduct("weight")%>克</td>
        	    <td align="center"><%=rsproduct("qty")%></td>
        	    <td align="center" class="font14 fontstorg"><%=rsproduct(sqlField)%></td>
       	      </tr>
              <%
        rslist.movenext
        loop
        rslist.close
        set rslist=nothing
        end if		 
        %>
        	  
       	    </table>
    
    </td>
    </tr>
    <tr>
      <td colspan="2"><strong>订单信息</strong></td>
      </tr>
    
    
    <tr>
					<td bgcolor="#FFFFFF" class="select_td_1">商品合计重量</td>
		<td bgcolor="#FFFFFF"><%=rs("weight")%>克</td>
	  </tr>
				<tr>
					<td bgcolor="#FFFFFF" class="select_td_1">邮寄方式</td>
					<td bgcolor="#FFFFFF">
                    <%set rss=conn.execute("select title from InterTransCost where id="&rs("InterTransType"))
					 if not rss.eof then
					 response.write rss("title")
					 end if
					 set rss=nothing%>
                  </td>
	  </tr>
				<tr>
					<td bgcolor="#FFFFFF" class="select_td_1">国际运费</td>
				  <td bgcolor="#FFFFFF"><%=cdbl(rs("InterTransCost"))*cdbl(rs("Rate"))%>RMB</td>
	  </tr>
				<tr>
					<td bgcolor="#FFFFFF" class="select_td_1">包装形式</td>
					<td bgcolor="#FFFFFF">
                    <%set rss=conn.execute("select title from PackageCost where id="&rs("PackageType"))
								 if not rss.eof then
								 response.write rss("title")
								 end if
								 set rss=nothing%>
                  </td>
	  </tr>
				<tr>
					<td bgcolor="#FFFFFF" class="select_td_1">包装材料费</td>
				  <td bgcolor="#FFFFFF"><%=cdbl(rs("PackageCost"))*cdbl(rs("Rate"))%>RMB</td>
	  </tr>
				<tr>
					<td bgcolor="#FFFFFF" class="select_td_1">是否加入保险</td>
				  <td bgcolor="#FFFFFF"><%IF RS("IsUsedSafety")=true then response.Write "是" else response.Write "否"%></td>
	  </tr>
				<tr>
					<td bgcolor="#FFFFFF" class="select_td_1">保险费</td>
				  <td bgcolor="#FFFFFF"><%=rs("SafetyCost")%>RMB</td>
	  </tr>
				<tr>
					<td bgcolor="#FFFFFF" class="select_td_1">转运服务费</td>
				  <td bgcolor="#FFFFFF"><%=CDBL(RS("TransCost"))*cdbl(rs("Rate"))%>RMB</td>
	  </tr>
				<tr>
					<td bgcolor="#FFFFFF" class="select_td_1">合计费用</td>
				  <td bgcolor="#FFFFFF"><%=(CDBL(RS("TransCost"))+CDBL(RS("InterTransCost"))+CDBL(RS("PackageCost")))*cdbl(rs("Rate"))%></td>
	  </tr>
				<tr>
					<td bgcolor="#FFFFFF" class="select_td_1">收货地址</td>
				  <td bgcolor="#FFFFFF"><%=RS("Location")&" "&RS("CodeZip")&" "&RS("Name")&" "&RS("TEL")%></td>
	  </tr>
    
    
    
    
    
    <tr>
      <td width="15%" bgcolor="#FFFFFF">&nbsp;</td>
      <td width="85%" bgcolor="#FFFFFF"><%=RS("content")%></td>
    </tr>
  </table>

</div>
</div>
</body>
</html>
<%
rs.close
set rs=nothing
end if
%>